Tabela CO_INVOICE

Definicja tabeli CO_INVOICE

Name

CO_INVOICE

Code

CO_INVOICE

Comment

 


Lista kolumn tabeli CO_INVOICE

Name

Code

CO_INVOICEID

CO_INVOICEID

INVOICENO

INVOICENO

NUMBERINCREMENTPART

NUMBERINCREMENTPART

NUMBERRESETPART

NUMBERRESETPART

CREATEDT

CREATEDT

BUYINGDT

BUYINGDT

PAYMENTDT

PAYMENTDT

CO_CATERINGORDERID

CO_CATERINGORDERID

SELLERNAME

SELLERNAME

SELLERADDRESS

SELLERADDRESS

SELLERNIP

SELLERNIP

SELLERACCOUNT

SELLERACCOUNT

BUYERNAME

BUYERNAME

BUYERADDRESS

BUYERADDRESS

BUYERNIP

BUYERNIP

INSERTDATE

INSERTDATE

INSERTINGPERSON

INSERTINGPERSON

LASTMODIFIEDPERSON

LASTMODIFIEDPERSON

LASTMODIFIEDDT

LASTMODIFIEDDT


Kolumna CO_INVOICEID tabeli CO_INVOICE

Definicja kolumny CO_INVOICEID tabeli CO_INVOICE

Name

CO_INVOICEID

Code

CO_INVOICEID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna INVOICENO tabeli CO_INVOICE

Definicja kolumny INVOICENO tabeli CO_INVOICE

Name

INVOICENO

Code

INVOICENO

Data Type

VARCHAR2(255)

Mandatory

Yes

Comment

 


Kolumna NUMBERINCREMENTPART tabeli CO_INVOICE

Definicja kolumny NUMBERINCREMENTPART tabeli CO_INVOICE

Name

NUMBERINCREMENTPART

Code

NUMBERINCREMENTPART

Data Type

NUMBER(38,2)

Mandatory

Yes

Comment

 


Kolumna NUMBERRESETPART tabeli CO_INVOICE

Definicja kolumny NUMBERRESETPART tabeli CO_INVOICE

Name

NUMBERRESETPART

Code

NUMBERRESETPART

Data Type

NUMBER(38,2)

Mandatory

Yes

Comment

 


Kolumna CREATEDT tabeli CO_INVOICE

Definicja kolumny CREATEDT tabeli CO_INVOICE

Name

CREATEDT

Code

CREATEDT

Data Type

DATE

Mandatory

Yes

Comment

 


Kolumna BUYINGDT tabeli CO_INVOICE

Definicja kolumny BUYINGDT tabeli CO_INVOICE

Name

BUYINGDT

Code

BUYINGDT

Data Type

DATE

Mandatory

Yes

Comment

 


Kolumna PAYMENTDT tabeli CO_INVOICE

Definicja kolumny PAYMENTDT tabeli CO_INVOICE

Name

PAYMENTDT

Code

PAYMENTDT

Data Type

DATE

Mandatory

Yes

Comment

 


Kolumna CO_CATERINGORDERID tabeli CO_INVOICE

Definicja kolumny CO_CATERINGORDERID tabeli CO_INVOICE

Name

CO_CATERINGORDERID

Code

CO_CATERINGORDERID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna SELLERNAME tabeli CO_INVOICE

Definicja kolumny SELLERNAME tabeli CO_INVOICE

Name

SELLERNAME

Code

SELLERNAME

Data Type

VARCHAR2(255)

Mandatory

Yes

Comment

 


Kolumna SELLERADDRESS tabeli CO_INVOICE

Definicja kolumny SELLERADDRESS tabeli CO_INVOICE

Name

SELLERADDRESS

Code

SELLERADDRESS

Data Type

VARCHAR2(255)

Mandatory

Yes

Comment

 


Kolumna SELLERNIP tabeli CO_INVOICE

Definicja kolumny SELLERNIP tabeli CO_INVOICE

Name

SELLERNIP

Code

SELLERNIP

Data Type

VARCHAR2(20)

Mandatory

Yes

Comment

 


Kolumna SELLERACCOUNT tabeli CO_INVOICE

Definicja kolumny SELLERACCOUNT tabeli CO_INVOICE

Name

SELLERACCOUNT

Code

SELLERACCOUNT

Data Type

VARCHAR2(30)

Mandatory

Yes

Comment

 


Kolumna BUYERNAME tabeli CO_INVOICE

Definicja kolumny BUYERNAME tabeli CO_INVOICE

Name

BUYERNAME

Code

BUYERNAME

Data Type

VARCHAR2(255)

Mandatory

Yes

Comment

 


Kolumna BUYERADDRESS tabeli CO_INVOICE

Definicja kolumny BUYERADDRESS tabeli CO_INVOICE

Name

BUYERADDRESS

Code

BUYERADDRESS

Data Type

VARCHAR2(255)

Mandatory

Yes

Comment

 


Kolumna BUYERNIP tabeli CO_INVOICE

Definicja kolumny BUYERNIP tabeli CO_INVOICE

Name

BUYERNIP

Code

BUYERNIP

Data Type

VARCHAR2(20)

Mandatory

Yes

Comment

 


Kolumna INSERTDATE tabeli CO_INVOICE

Definicja kolumny INSERTDATE tabeli CO_INVOICE

Name

INSERTDATE

Code

INSERTDATE

Data Type

DATE

Mandatory

No

Comment

 


Kolumna INSERTINGPERSON tabeli CO_INVOICE

Definicja kolumny INSERTINGPERSON tabeli CO_INVOICE

Name

INSERTINGPERSON

Code

INSERTINGPERSON

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LASTMODIFIEDPERSON tabeli CO_INVOICE

Definicja kolumny LASTMODIFIEDPERSON tabeli CO_INVOICE

Name

LASTMODIFIEDPERSON

Code

LASTMODIFIEDPERSON

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LASTMODIFIEDDT tabeli CO_INVOICE

Definicja kolumny LASTMODIFIEDDT tabeli CO_INVOICE

Name

LASTMODIFIEDDT

Code

LASTMODIFIEDDT

Data Type

DATE

Mandatory

No

Comment

 


Lista kluczy tabeli CO_INVOICE

Name

Code

Primary

PK_CO_INVOICE

PK_CO_INVOICE

X


Klucz PK_CO_INVOICE tabeli CO_INVOICE

Definicja klucza PK_CO_INVOICE tabeli CO_INVOICE

Name

PK_CO_INVOICE

Code

PK_CO_INVOICE

Primary

Yes

Comment